How to: Convert text so all text is lowercase regardless of how it was entered.
Solution:
In the Form Design view, use the 'Format' property box in the property sheet of the form. Type a '<' to convert text to all lowercase.
NOTE: Access does not support a code for this request. However, it is possible to convert text to all uppercase or all lowercase.
1) If the Database window is not activated, activate the Database window.
2) Click the 'Forms' tab in the Database window.
Forms tab
3) Select the desired form from the list box. (The selected form is highlighted.)
4) Click 'Design'. (The selected form appears in Design view, and the floating Toolbox appears.)
5) Click on the desired control to convert.
6) Select the 'View' menu and select 'Properties'.
7) Click the 'Format' tab.
8) Click on the 'Format' box.
9) To convert text to all lowercase, type the following:
<
10) Select the 'File' menu and select 'Save' to save the form.
